﻿CREATE TABLE [trUser].[tblCities] (
    [IDCity]       BIGINT        IDENTITY (1, 1) NOT NULL,
    [IDCountry]    BIGINT        NOT NULL,
    [IDState]      BIGINT        NULL,
    [IDCounty]     BIGINT        NULL,
    [IDPostalCode] BIGINT        NULL,
    [City]         NVARCHAR (50) NULL,
    [DateCreated]  DATETIME      CONSTRAINT [DF_tblCities_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]  DATETIME      NULL,
    [DateInactive] DATETIME      NULL,
    CONSTRAINT [PK_tblCities] PRIMARY KEY CLUSTERED ([IDCity] ASC)
);

